TG: sql_for_qa/59

SQL для тестировщика

Какой из следующих SQL запросов выведет имена сотрудников и их менеджеров из таблиц "employee" и "manager"? Рядом с именем каждого сотрудника должно быть выведено имя его менеджера.

Anonymous Quiz

SELECT employee.name, manager.name FROM employee, manager WHERE employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee JOIN manager ON employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee INNER JOIN manager ON employee.manager=manager.id;

SELECT employee.name, manager.name FROM employee LEFT JOIN manager ON employee.manager=manager.id;

631 answered

www.tg-me.com/sg/SQL для тестировщика/com.sql_for_qa/59

2.6K viewsMar 14, 2023 at 06:20

tg-me.com/sql_for_qa/59

Create: 2023-03-14
Last Update: 2025-07-02 00:48:50

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/59

SQL для тестировщика Telegram | DID YOU KNOW?

Telegram announces Anonymous Admins

The cloud-based messaging platform is also adding Anonymous Group Admins feature. As per Telegram, this feature is being introduced for safer protests. As per the Telegram blog post, users can “Toggle Remain Anonymous in Admin rights to enable Batman mode. The anonymized admin will be hidden in the list of group members, and their messages in the chat will be signed with the group name, similar to channel posts.”

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.